/**
 * Software License, Version 1.0
 *
 * Copyright 2003 The Trustees of Indiana University.  All rights reserved.
 *
 *
 *Redistribution and use in source and binary forms, with or without
 *modification, are permitted provided that the following conditions are met:
 *
 *1) All redistributions of source code must retain the above copyright notice,
 * the list of authors in the original source code, this list of conditions and
 * the disclaimer listed in this license;
 *2) All redistributions in binary form must reproduce the above copyright
 * notice, this list of conditions and the disclaimer listed in this license in
 * the documentation and/or other materials provided with the distribution;
 *3) Any documentation included with all redistributions must include the
 * following acknowledgement:
 *
 *"This product includes software developed by the Community Grids Lab. For
 * further information contact the Community Grids Lab at
 * http://communitygrids.iu.edu/."
 *
 * Alternatively, this acknowledgement may appear in the software itself, and
 * wherever such third-party acknowledgments normally appear.
 *
 *4) The name Indiana University or Community Grids Lab or NaradaBrokering,
 * shall not be used to endorse or promote products derived from this software
 * without prior written permission from Indiana University.  For written
 * permission, please contact the Advanced Research and Technology Institute
 * ("ARTI") at 351 West 10th Street, Indianapolis, Indiana 46202.
 *5) Products derived from this software may not be called NaradaBrokering,
 * nor may Indiana University or Community Grids Lab or NaradaBrokering appear
 * in their name, without prior written permission of ARTI.
 *
 *
 * Indiana University provides no reassurances that the source code provided
 * does not infringe the patent or any other intellectual property rights of
 * any other entity.  Indiana University disclaims any liability to any
 * recipient for claims brought by any other entity based on infringement of
 * intellectual property rights or otherwise.
 *
 *LICENSEE UNDERSTANDS THAT SOFTWARE IS PROVIDED "AS IS" FOR WHICH NO
 *WARRANTIES AS TO CAPABILITIES OR ACCURACY ARE MADE. INDIANA UNIVERSITY GIVES
 *NO WARRANTIES AND MAKES NO REPRESENTATION THAT SOFTWARE IS FREE OF
 *INFRINGEMENT OF THIRD PARTY PATENT, COPYRIGHT, OR OTHER PROPRIETARY RIGHTS.
 *INDIANA UNIVERSITY MAKES NO WARRANTIES THAT SOFTWARE IS FREE FROM "BUGS",
 *"VIRUSES", "TROJAN HORSES", "TRAP DOORS", "WORMS", OR OTHER HARMFUL CODE.
 *LICENSEE ASSUMES THE ENTIRE RISK AS TO THE PERFORMANCE OF SOFTWARE AND/OR
 *ASSOCIATED MATERIALS, AND TO THE PERFORMANCE AND VALIDITY OF INFORMATION
 *GENERATED USING SOFTWARE.
 */
/**
 * Software License, Version 1.0
 *
 * Copyright 2003 The Trustees of Indiana University.  All rights reserved.
 *
 *
 *Redistribution and use in source and binary forms, with or without
 *modification, are permitted provided that the following conditions are met:
 *
 *1) All redistributions of source code must retain the above copyright notice,
 * the list of authors in the original source code, this list of conditions and
 * the disclaimer listed in this license;
 *2) All redistributions in binary form must reproduce the above copyright
 * notice, this list of conditions and the disclaimer listed in this license in
 * the documentation and/or other materials provided with the distribution;
 *3) Any documentation included with all redistributions must include the
 * following acknowledgement:
 *
 *"This product includes software developed by the Community Grids Lab. For
 * further information contact the Community Grids Lab at
 * http://communitygrids.iu.edu/."
 *
 * Alternatively, this acknowledgement may appear in the software itself, and
 * wherever such third-party acknowledgments normally appear.
 *
 *4) The name Indiana University or Community Grids Lab or NaradaBrokering,
 * shall not be used to endorse or promote products derived from this software
 * without prior written permission from Indiana University.  For written
 * permission, please contact the Advanced Research and Technology Institute
 * ("ARTI") at 351 West 10th Street, Indianapolis, Indiana 46202.
 *5) Products derived from this software may not be called NaradaBrokering,
 * nor may Indiana University or Community Grids Lab or NaradaBrokering appear
 * in their name, without prior written permission of ARTI.
 *
 *
 * Indiana University provides no reassurances that the source code provided
 * does not infringe the patent or any other intellectual property rights of
 * any other entity.  Indiana University disclaims any liability to any
 * recipient for claims brought by any other entity based on infringement of
 * intellectual property rights or otherwise.
 *
 *LICENSEE UNDERSTANDS THAT SOFTWARE IS PROVIDED "AS IS" FOR WHICH NO
 *WARRANTIES AS TO CAPABILITIES OR ACCURACY ARE MADE. INDIANA UNIVERSITY GIVES
 *NO WARRANTIES AND MAKES NO REPRESENTATION THAT SOFTWARE IS FREE OF
 *INFRINGEMENT OF THIRD PARTY PATENT, COPYRIGHT, OR OTHER PROPRIETARY RIGHTS.
 *INDIANA UNIVERSITY MAKES NO WARRANTIES THAT SOFTWARE IS FREE FROM "BUGS",
 *"VIRUSES", "TROJAN HORSES", "TRAP DOORS", "WORMS", OR OTHER HARMFUL CODE.
 *LICENSEE ASSUMES THE ENTIRE RISK AS TO THE PERFORMANCE OF SOFTWARE AND/OR
 *ASSOCIATED MATERIALS, AND TO THE PERFORMANCE AND VALIDITY OF INFORMATION
 *GENERATED USING SOFTWARE.
 */
package cgl.narada.service.storage.db;

import cgl.narada.service.ServiceException;
import cgl.narada.service.storage.file.ManageDB;

// The TableManager will be responsible for creating and dropping tables
public class TableManager {

  private DataAccessObject dao;
  private String impl;
  private ManageDB mdb;

  public TableManager(String impl) {
    this.impl = impl;
    DataAccessObject dao = null;

    DatabaseFactory df = new DatabaseFactory();
    try {
      dao = df.getDAO();
    }
    catch (Exception ex) {
      System.out.println("exception in creating DataAccessObject ");
    }

    mdb = new ManageDB();
  }

  public void createInventoryFullTable() throws ServiceException {
    if (impl.equals("db")) {
      dao.executePreparedQuery(NbTables.CreateInventoryFull);
    }
    else if (impl.equals("file")) {
      mdb.createInventory();
    }
  }

  public void createInventoryLightTable() throws ServiceException {
    if (impl.equals("db")) {
      dao.executePreparedQuery(NbTables.CreateInventoryLight);
    }

  }

  public void createEntityInventoryTable() throws ServiceException {
    if (impl.equals("db")) {
      dao.executePreparedQuery(NbTables.CreateEntityInventory);
    }
    else if (impl.equals("file")) {
      mdb.createEntityInventory();
    }

  }

  public void createEntityTemplateTable() throws ServiceException {
    if (impl.equals("db")) {
      dao.executePreparedQuery(NbTables.CreateEntityTemplate);
    }
    else if (impl.equals("file")) {
      mdb.createEntityTemplate();
    }

  }

  public void createTemplateTable() throws ServiceException {
    if (impl.equals("db")) {
      dao.executePreparedQuery(NbTables.CreateTemplate);
    }
    else if (impl.equals("file")) {
      mdb.createTemplate();
    }

  }

  public void createProfileTable() throws ServiceException {
    if (impl.equals("db")) {
      dao.executePreparedQuery(NbTables.CreateProfile);
    }
    else if (impl.equals("file")) {
      mdb.createProfile();
    }
  }

  public void createEntityTable() throws ServiceException {
    if (impl.equals("db")) {
      dao.executePreparedQuery(NbTables.CreateEntity);
    }
    else if (impl.equals("file")) {
      mdb.createEntity();
    }

  }

  public void createTables() throws ServiceException {
    this.createInventoryFullTable();
    this.createInventoryLightTable();
    this.createEntityInventoryTable();
    this.createEntityTemplateTable();
    this.createTemplateTable();
    this.createProfileTable();
    this.createEntityTable();
  }

  public void dropInventoryFullTable() throws ServiceException {
    if (impl.equals("db")) {
      dao.executePreparedQuery(NbTables.DropInventoryFull);
    }
    else if (impl.equals("file")) {
      mdb.dropInventory();
    }

  }

  public void dropInventoryLightTable() throws ServiceException {
    if (impl.equals("db")) {
      dao.executePreparedQuery(NbTables.DropInventoryLight);
    }
  }

  public void dropEntityInventoryTable() throws ServiceException {

    if (impl.equals("db")) {
      dao.executePreparedQuery(NbTables.DropEntityInventory);
    }
    else if (impl.equals("file")) {
      mdb.dropEntityInventory();
    }
  }

  public void dropEntityTemplateTable() throws ServiceException {

    if (impl.equals("db")) {
      dao.executePreparedQuery(NbTables.DropEntityTemplate);
    }
    else if (impl.equals("file")) {
      mdb.dropEntityTemplate();
    }
  }

  public void dropTemplateTable() throws ServiceException {
    if (impl.equals("db")) {
      dao.executePreparedQuery(NbTables.DropTemplate);
    }
    else if (impl.equals("file")) {
      mdb.dropTemplate();
    }

  }

  public void dropProfileTable() throws ServiceException {
    if (impl.equals("db")) {
      dao.executePreparedQuery(NbTables.DropProfile);
    }
    else if (impl.equals("file")) {
      mdb.dropProfile();
    }

  }

  public void dropEntityTable() throws ServiceException {
    if (impl.equals("db")) {
      dao.executePreparedQuery(NbTables.DropEntity);
    }
    else if (impl.equals("file")) {
      mdb.dropEntity();
    }

  }

  public void dropTables() throws ServiceException {
    this.dropInventoryFullTable();
    this.dropInventoryLightTable();
    this.dropEntityInventoryTable();
    this.dropEntityTemplateTable();
    this.dropTemplateTable();
    this.dropProfileTable();
    this.dropEntityTable();
  }

  public static void main(String[] args) {
    System.out.println("create TableManager");
    TableManager tm = new TableManager(args[0]);
    System.out.println("finish create TableManager");

    try {
      tm.dropTables();
      System.out.println("finish drop tables");
    }
    catch (ServiceException ex) {

    }

    try {
      tm.createTables();
    }
    catch (ServiceException ex1) {
    }

  }
}